Accounts dimension

From the Manage ACCT page, you can manage the Accounts dimension, which contains records for each account in the GL of your organization. This includes accounts that can be found on the balance sheet, income statement, and statistics.

TIP: You can manage your dimension tables by downloading them in spreadsheet form so that you can make larger changes more easily. You can then upload the spreadsheet with the changes back into the system database. For more information, see Editing a dimension using a spreadsheet.

To access the ACCT dimension:

1. From the Command Center home page, select System Administration.

   

   Click image to view full size

2. On the System Administration page, click Manage Data.

   

   Click image to view full size

3. On the Accounts sub-tab, click Open.

   

   Click image to view full size

NOTE: The page can only display up to a maximum of 10,000 records.

Filtering records

To filter records:

1. Click the funnel icon in the upper left corner of the page.

   

2. In the Filter box, you can narrow down the records to display by selecting or creating a filter using the Filter Wizard. To access the Filter Wizard, click Edit. If you are familiar with writing filter statements, you can type the statement syntax directly in the Filter box.
3. Click Apply.

Adding or editing an account

Due to the large number of records that this table may contain, you need to use the Filter panel to identify the records to display.

To add or edit an account:

1. In the table, do any of the following:

   • To add an account, click Add Row. The new row displays at the bottom of the table. Enter information in each column. After you save, the table will display the new row in order by the ACCT column.

     NOTE: You can optionally add multiple rows to an account by clicking Add Rows. This displays the Add Rows dialog box, where you enter the number of rows that you want to add.

     IMPORTANT: If you add a new record that already exists in the table, the system will overwrite the original column values with your new entries when you save your changes. We recommend that you review your entries before saving any changes.

   • To edit an account, click in the cell(s) to make your changes.

     NOTE: Columns that are grayed out cannot be edited.

   • To undo your changes, click the left arrow icon.
   • To redo your changes, click the right arrow icon .
2. When you finish making changes, click Save.

Deleting an account

Due to the large number of records that this table may contain, you need to use the Filter panel to identify the records to display.

To delete an account:

1. In the table, select the row to highlight it, and then click Delete Row.

2. At the Continue? prompt, click OK.
3. When you finish making changes, click Save.

Column descriptions

This section provides descriptions for each column in the Accounts dimension table:

Column Name	Description
ACCT	The GL account number. The data type always has to integer. Integer columns can store a maximum of 19 digits.
Description	The GL account number description.
NewAcct	Do the following: When a new account is added using a GL import, select True. After new accounts are reviewed and approved, then set the value to False.
AcctType	The GL account type classifications for balance sheet and income statement accounts. This column references column AcctType.AX_AcctType. Axiom comes with a number of standard account types.
AccrualBasis	References the AccrualBasis.AX_Accrual_Basis column. The accrual basis codes of either ACT_ACT or Thirty_360 are assigned to balance sheet accounts. The AX_Accrual_Basis column is used in the creation of annualized interest records for yield reporting and by Axiom calculated columns within the GL and Management GL tables.
YieldDTYPE	The yield data type column that must be assigned to all interest income/expense accounts for yield reporting records. This column references the DTYPE.DTYPE column. For more information about yield reporting data types, see DTYPE dimension.
BalanceSheetAcct	The balance sheet account number to which interest income and interest expense accounts are associated. This column is used by Axiom to map interest income/expense amounts to balance sheet account numbers as the associated YieldDtype to create yield reporting records. The AX_BSACCT column references ACCT.ACCT column. The default value of AX_BSACCT is 0.
TaxEquivalent	Specifies whether the account is taxable or not.
DebitCreditCode	Specifies whether an account's positive balance is a debit or credit.
ReportSign	The report sign applied to GL trial balance reports.
BudgetActRollup	The Axiom budget account.
BudgetDescription	The description of the Axiom planning - budget account.
ForecastAcctRollup	The Axiom forecast account.
ForecastDescription	The description of the Axiom forecast account.
IsInterestAcct	Do one of the following: If the account is an interest income or expense account, select True. If the account is not an interest income or expense account, select False.
BudgetInUtility	Specifies that the account's budget projections are calculated by a budget utility. The system will exclude the account from the budget plan files.
ForecastInUtility	Specifies that the account's budget projections are calculated by a budget utility. The system will exclude the account from the budget plan files.
BudgetBalancing	The assignment of the account to a balancing utility category.
ForecastBalancing	The assignment of the account to a balancing utility category.
LoanLossReserveType	Identifies the predefined account types, such as Loan Balance, Reserve, etc. used by the planning Loan Loss Reserve utility.
LoanLossReserveCategory	Identifies the loan category to which a loan account belongs.
BudgetPlanCode	Specifies the budget plan code for a budget account that is to be centrally planned.
ForecastPlanCode	Specifies the forecast plan code for a forecast account that is to be centrally planned.
BudgetSheetSection	Specifies the section of a budget plan file where an account displays.
ForecastSheetSection	Specifies the section of a forecast plan where an account displays.
BudgetCalcMethod	The calculation method associated with the budget account.
ForecastCalcMethod	The calculation method associated with the forecast account.
BudgetNonTaxable	This field informs the Bank Balancer utility as to whether a budget income or expense account is non-taxable.
ForecastNonTaxable	This field informs the Bank Balancer utility as to whether a forecast income or expense account is non-taxable.
BudgetStatAcct	Specifies the statistical budget account associated with the budget account to be used by the NonInterest Driver Based Growth calculation method.
ForecastStatAcct	Specifies the statistical budget account associated with the forecast account to be used by the NonInterest Driver Based Growth calculation method.
PoolType	The profitability pool type.
RAROCBalanceSheet	The risk-adjusted return on capital balance sheet grouping.
RAROCBalanceSheetOrder	The risk-adjusted return on capital balance sheet order number.
Custom1-30	Optional custom columns that can be used by your institution, including assigning a preferred column name. NOTE: For details on editing custom columns, which is only available in the Axiom Windows Client at this time, see Column properties.

NOTE: The table may display some columns that are related to other Kaufman Hall products or have been created specifically for your organization. Contact your Kaufman Hall Implementation Consultant or Kaufman Hall Support if you need help with these columns.